SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402560 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402560 [ RunTime:0.003023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640058,597268,582094,52843,557372,524027,5716,35915,864632,777363,355628,554648,28986,423090,1040974,56640,530528,956221,305805,991294,540203,161912,485847,435806,1047873,996894,324154,262012,202004,389904,494561,690320,443793,254707,184389,849560,785638,268276,471518,383755,601538,858828,967267,106520,986343,476246,301599,860637,841663,441839,324631,184804,462624,619860,791114,394118,1028684,312071,125555,576205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000721s ]