SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473547 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473547 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467311,151341,898358,333411,915151,173258,651615,897097,293139,173181,249297,2078,511810,173634,159370,794782,168508,762534,134105,717057,255314,997306,953398,735172,17889,780164,684213,275862,983528,729551,603615,246851,214626,890105,193829,577216,945221,712069,553098,480099,312562,30968,780625,985103,999877,898277,918927,1046958,688135,514085,446247,775380,840306,618355,824926,1038466,1019473,131601,1043968,761188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473547 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473547 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000759s ]