SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 160181 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 160181 [ RunTime:0.007264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001570,343203,996011,761997,534253,16632,454064,67296,267215,245285,838595,30911,730476,642680,420755,226193,270785,1003984,399058,894798,835104,752176,21470,952077,235732,866826,223477,496858,91341,519451,374198,1007094,798136,1005976,75287,85803,631620,17647,327051,102881,269672,947347,145140,545382,80558,686866,365170,565695,1019591,469146,556827,631756,61026,949679,271105,919983,578428,748549,741269,820062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 160181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005787s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 160181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007725s ]