SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027389 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027389 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82668,559140,681191,143765,647774,356383,338329,30364,24155,281173,974937,192370,969288,577025,213600,784212,677190,582494,866018,794181,33889,989024,351206,478782,413178,44751,106402,964218,664150,52596,914873,1029023,235330,900940,417379,510544,622398,452793,923530,290948,200835,879604,29718,12881,827908,207506,23716,127723,842517,783436,913227,338526,34926,25704,683230,327252,323033,768737,580176,111674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]