SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010091 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010091 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353523,506842,27750,898734,383827,441952,843472,444756,237119,78644,349171,599220,1021260,945169,160636,243945,692797,105606,1033219,54747,474587,593475,831382,858822,746445,102717,761581,64611,172771,660782,397477,88879,92523,728353,466396,442840,363177,806015,1001549,111625,795292,257322,46251,695888,304553,25213,146255,401001,644287,750571,663245,573617,39563,940290,884938,204878,207531,142361,63100,172612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]