SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328708 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328708 [ RunTime:0.002170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011795,945018,176214,1025200,925924,224164,443116,418836,453214,563373,458275,664529,200410,333348,644577,953421,925239,68002,188291,59252,529682,944138,774048,117779,1022002,419759,969097,662951,958089,342376,665973,1010051,589131,102471,530394,631153,144677,656830,72563,407566,68112,628597,442611,428412,850676,9634,1005835,55843,674469,717105,194960,826430,580076,779370,457729,514059,359130,418359,130064,780563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001115s ]