SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027032 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027032 [ RunTime:0.002794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540389,126499,897203,672862,246309,733600,607439,257003,193819,226419,83878,118439,1021075,46321,567184,325423,1046348,554411,412519,733866,591651,444067,111895,836627,200502,115001,633278,666547,218539,524008,997977,71751,516818,560257,78037,482194,967890,179935,133888,959624,938746,322618,864406,811333,235656,187305,715777,67323,488710,831649,487496,444404,260249,552600,178197,1015335,780437,890408,602803,849474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]