SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552912 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552912 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604404,896687,695388,78187,799514,485238,292281,316785,950822,983087,423898,425496,233514,549048,454816,209696,899012,320737,812617,540518,537911,425117,933119,548118,101986,1003407,448356,17566,299180,228773,436415,52611,95208,81631,284230,1003224,404521,404817,542872,134604,93953,165435,69422,287136,901909,228961,360144,670166,376790,495106,350908,668503,173307,21881,704366,1047245,805038,588635,771749,758177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]