SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001820s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402479 LIMIT 1 [ RunTime:0.000559s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402479 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485584,1043070,303903,229037,221240,782214,182192,275866,468240,805565,706828,81410,678517,858802,686463,746857,1004976,831307,501867,866358,806997,681350,352967,348775,635516,226,574847,174671,424935,314132,944531,989864,438653,191769,281126,299540,822775,905558,863644,500321,370516,493314,162594,625773,501619,490740,725014,275654,52445,291047,18086,879938,142436,37877,68813,244836,8548,493955,853890,915540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001235s ]