SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420418 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420418 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376878,967222,410693,883788,220117,715095,201435,1022504,572032,771756,225959,599339,623745,685393,809959,766145,822339,320075,723930,497406,309364,728206,573244,944417,743336,136698,19500,625530,212396,60602,588319,426002,899072,399186,240369,613368,321762,11841,899128,468859,947703,784715,359189,686543,73126,14096,453470,504328,872620,662551,112384,57312,179860,570458,986329,904222,886782,894110,621130,421070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]