SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001913s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499805 LIMIT 1 [ RunTime:0.003064s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499805 [ RunTime:0.005401s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38736,259812,650467,990809,332279,1019474,1046050,368788,979738,405182,616166,743506,831851,145371,237550,778300,1040165,113166,976862,716662,1009988,896033,484620,956182,913521,651317,50453,991633,540392,167555,779128,565627,262080,694902,370161,974556,60648,664385,948542,816063,433458,251410,439380,94709,82862,338602,532705,235500,184335,758891,634077,665550,892915,564768,895628,865408,507104,848950,127045,952526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]