SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420274 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420274 [ RunTime:0.002716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337404,50189,871027,30421,251254,799665,641678,426626,263152,666483,461720,815565,816397,281501,147777,851884,629739,887686,89650,606641,833186,117290,719687,493529,596982,131375,729201,544241,609841,430514,656872,982107,302996,741912,955359,650468,292002,314191,83199,252023,803592,3722,190918,573924,386623,722192,77379,640052,95188,966299,1007078,393876,808783,384390,396207,621586,678897,702572,532906,415503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420274 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420274 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002253s ]