SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342380 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342380 [ RunTime:0.006302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318186,812895,25714,285694,49288,297234,397169,38728,71110,955409,608973,608219,74218,669580,337738,946507,109396,430841,969269,650461,155609,472665,258313,303556,1044079,1038990,919727,470890,269566,543645,759078,513596,873078,654570,681082,404291,161918,131955,421420,256189,998785,446570,107608,622852,1645,1028808,35154,917506,321974,90321,800144,665288,728073,879807,632651,245163,647508,858215,348115,446988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]