SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034114 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034114 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114894,642342,354257,360440,1019290,95217,657154,231908,769676,249199,805027,849601,655623,595504,783146,117082,187085,164300,1047113,182041,936917,253905,365969,303270,691445,461032,465717,591726,456408,939740,34759,1046527,238508,95596,719019,528941,1016524,316776,166312,52858,579585,67926,205998,160052,188931,1004608,1017772,181800,88021,221385,437746,136507,944048,459671,522023,652815,776784,513207,403540,23453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]