SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34890 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34890 [ RunTime:0.003539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575561,28435,417400,215923,448594,1048619,734034,759867,757051,924266,65800,351718,361489,545680,505019,1047133,364975,818978,460472,164376,357038,609824,616718,303313,574952,645261,257901,408900,3149,1004458,316201,519778,621957,949735,563821,995363,565928,965170,216417,300420,805449,1013299,737923,235833,607805,134074,10749,486754,260483,116247,438076,207654,232982,600384,931941,84101,87157,443652,809954,442068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]