SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010281 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010281 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81446,786793,512424,404225,764742,941791,650619,995236,289062,120552,747526,861291,49857,505706,142340,606086,84118,778452,749692,228870,251491,586339,533867,803101,343858,151061,482015,146604,690156,1025476,750632,857431,328805,425648,325761,646869,60531,966258,1040824,1045655,430407,283152,977081,448806,501903,624907,688075,218197,300630,409360,689596,892203,519540,375031,492397,478251,165856,138703,425103,239870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]