SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428030 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428030 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268366,1035944,687718,925838,507063,1037215,849199,875425,134574,1003550,387823,350188,93615,740722,404991,634831,53372,794797,93809,655687,827968,726272,904235,279622,596700,9222,1047654,992151,398957,572757,908665,970045,880945,672028,388032,770276,448572,1012362,448540,820705,347069,596850,774475,945743,109923,222416,876019,45936,810194,472970,758523,1026878,386099,171676,1010634,502117,242127,709236,64124,410373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]