SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043988 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043988 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733636,832027,556963,403437,969821,749399,824409,699655,471153,550597,806615,301957,626199,130417,94805,347377,862781,364155,413324,470090,167862,224207,835312,966096,513641,437888,869615,895699,142588,835184,423401,34742,650661,646207,298974,747027,327657,1013729,603377,530186,203507,595683,155429,800285,417154,811826,561659,695790,628111,376134,1035567,673223,266205,948015,282316,657841,899100,191985,529253,343089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000377s ]