SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502104 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502104 [ RunTime:0.007405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644424,653871,472431,558800,412712,742210,68931,413412,792463,984533,142997,737369,469729,684031,59641,240222,30719,16853,853941,812222,971078,686374,766854,786118,475738,546157,357519,635534,667466,109108,653855,781218,520616,788175,669953,965044,937675,567983,340688,642509,130300,988574,253340,665886,1046180,1026250,783066,1005667,699182,759146,492012,811771,196586,488536,511892,347828,817139,88538,300385,57321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000711s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002807s ]