SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404311 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404311 [ RunTime:0.002117s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772023,778543,1004478,527684,566259,407978,157751,895026,62178,338658,435334,801189,953031,463148,849911,101078,974412,973726,294094,209159,503992,565584,649326,117079,996154,618479,201371,1037712,237230,821802,1020367,727813,239445,545353,97029,696623,266055,344741,252166,613294,766495,1030926,333543,464108,252214,214363,834612,151756,552336,571225,1013029,226824,131466,537331,13024,408725,96756,775932,225222,728797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]