SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901717 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901717 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247813,556942,498993,402779,404135,297354,485907,51904,389841,866598,970465,123325,134597,604281,378788,1041939,762608,582596,331164,354988,752587,144485,421918,49932,411050,192845,754777,457537,209100,676588,486049,1019266,947732,284510,390773,967534,1045276,539956,249703,2766,1006172,546854,983636,795088,843003,946161,601689,479542,663059,345668,159281,806345,140379,949863,226007,298134,421958,597604,478760,974513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]