SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006142 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006142 [ RunTime:0.003396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011841,1041916,192047,636204,982529,193545,801765,440989,247847,103950,832306,306915,1030647,303815,459101,830464,598435,272403,343411,793751,395308,445178,237002,961838,506993,295718,861066,788032,789379,960955,576102,618807,737849,775690,359248,310235,52175,177618,306985,618969,572942,863145,667689,745558,857695,784156,881199,252616,94919,521524,196473,985130,929796,177811,455461,391193,358071,521679,176875,467446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]