SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501015 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501015 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260023,987304,651114,749376,709828,414805,592844,806135,586465,276618,263397,350706,81228,572275,298443,976276,816029,771914,447902,920019,670505,131282,538189,996166,755587,819760,698844,696433,721504,1007638,494552,930895,197791,11094,132755,270053,145688,366897,308642,32787,614360,43973,787315,1027752,984212,211003,667366,42949,636341,1017971,202870,69898,848660,43976,434521,288061,954246,467109,984398,182569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]