SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557341 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557341 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30065,709720,164979,272213,785649,519351,676792,324918,811411,63564,226528,127056,144815,685043,713471,460132,442167,256781,180466,635071,688960,221978,767830,300994,981400,393285,898397,268545,157708,788347,466853,667756,886219,934848,81962,587089,218801,465696,619711,956137,827712,913288,154863,86870,178752,549091,717598,732515,365497,191436,525953,390105,83199,706155,377565,186037,883208,982583,326167,664263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]