SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001809s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801028 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801028 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755684,346093,476387,363675,41131,428446,296801,1022370,795358,71648,434594,743074,633161,303066,676328,1028971,356263,66497,842422,212600,344051,678190,701598,135880,838715,249357,64656,734145,87385,385538,697181,4210,646014,602374,750948,516567,943197,725879,487523,32213,449982,493097,741588,756121,394668,525965,470731,264972,822102,1008651,967926,862295,987475,69619,56692,428738,219806,172919,775164,361222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]