SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419082 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419082 [ RunTime:0.001371s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850921,300985,832936,923710,563538,970916,286301,349484,555610,786300,820468,205213,39616,580002,382796,563527,54116,219658,573496,98811,364894,232418,614379,259143,542304,334834,972502,521722,979278,339073,60975,909764,380505,14139,186210,485595,225833,654686,570080,1000533,517073,225698,247392,1013966,499077,718946,357280,651342,726701,639043,300429,97372,881873,970233,820707,475234,529961,47900,1006509,918378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]