SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804951 LIMIT 1 [ RunTime:0.001399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804951 [ RunTime:0.005109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969712,930295,38275,952983,15091,11869,641875,1029784,215260,745912,868410,24242,386491,205790,896875,18268,151299,504578,591152,894945,140082,555661,349215,119352,841933,970088,260945,681797,781829,122996,583948,339286,435309,708551,542114,341450,510065,294362,918365,597241,313212,1014408,589111,764477,690504,787294,144698,481670,549043,636703,296176,465114,318047,400024,315622,552908,843633,761896,361742,1010822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004659s ]