SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 376836 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 376836 [ RunTime:0.001446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636830,1029342,808096,380151,73528,866317,787278,646391,347825,804084,125124,48803,135141,745639,641727,485892,1025854,131318,188169,450250,304114,920439,239609,794671,920309,632398,808863,746017,713385,800138,491254,550517,752250,961187,178948,152153,436544,97030,738287,1024382,974097,108404,826326,438557,806552,714849,761952,773668,855954,834943,768903,546412,946194,599426,324973,516955,515802,516570,336279,493159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 376836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 376836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]