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` = 322964 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322964 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650241,713138,691543,250606,1020392,607304,1019190,994162,574502,848813,785740,487345,834915,900175,674235,623332,638944,481684,345462,519351,852752,438572,505505,927479,26729,948013,525664,106755,248614,627224,831634,488627,503842,653145,874940,1046426,618254,424215,262309,62362,532900,1020113,392644,164980,852719,595387,759651,567132,320733,608323,905353,907885,478422,555949,685946,912171,955625,211933,106405,892487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003711s ]