SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287011 LIMIT 1 [ RunTime:0.000703s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287011 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246557,753427,806334,1032301,413070,292887,891462,133184,613375,351012,911583,963536,20005,727452,420965,1043603,143364,242541,699024,928180,39206,87332,731150,576618,942689,519283,600519,254073,764464,158963,203050,188947,768433,511168,886797,529101,422148,767380,112535,621323,484956,972552,1027800,824330,876565,233423,890163,26296,448634,312082,176054,44341,927453,553182,64094,757958,818032,223093,268640,1003542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]