SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418793 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418793 [ RunTime:0.001425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044813,795831,442127,920160,306280,813952,496814,919184,477198,75789,421674,351370,97894,941403,1038129,6060,941407,383143,617303,595184,667793,70116,538620,250800,907815,115375,408193,553257,968499,29841,72243,390180,203604,890952,40185,440044,471912,649917,272656,330732,104105,476359,488664,931394,601344,805436,985923,459712,224525,935620,58059,414470,593408,695017,423743,15287,43230,865292,35006,22632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418793 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418793 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]