SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501408 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501408 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125667,1045712,199706,177572,882775,599557,207554,122868,945837,1005370,116956,575986,243386,995568,1022859,836537,694217,429661,1040275,582485,722265,220750,481058,1042876,74386,505539,208709,400197,537921,110515,994495,705379,1027996,868140,821215,867629,425418,978428,852236,351153,531316,176463,433522,242699,194197,999902,831535,1008605,763365,837332,179742,185661,974194,1031159,342096,1031943,22767,609585,669673,973266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]