SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52860 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52860 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (880609,702829,807128,61095,133878,568857,399823,467917,772266,681606,760442,441063,725224,349530,687418,335632,984816,846603,315394,148635,609886,33887,664080,813290,510159,973090,825435,1027692,520775,1030018,957294,667925,285837,264656,777215,585363,467932,777759,548684,855292,750216,142334,825594,677160,121272,74025,262967,247395,1044765,272799,254854,150745,86750,878624,793770,927745,61782,425852,481879,657497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]