SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573480 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573480 [ RunTime:0.002048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124362,503240,635037,907918,1037237,359723,608997,1017903,641554,473215,850510,332025,297558,117908,15534,685440,280838,989164,942868,955551,728300,351246,1035297,313633,920882,147292,653126,432444,287474,725733,859644,887648,566251,467563,1048135,522814,465973,1001200,628398,702972,932486,165455,981088,451887,576673,131313,106517,86373,764461,6056,490960,645363,288213,363322,190132,14074,742055,344642,912090,711816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]