SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001748s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101380 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101380 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856282,627222,624945,543310,806139,521338,703076,149770,607988,490417,472363,623596,68157,857293,423925,397151,438993,512635,713816,689202,989889,269391,232145,818431,614545,686983,366996,611478,86966,24869,764458,56893,685532,251947,210400,52233,354211,484352,1025586,165504,348591,455552,644173,705487,820559,323397,343401,148362,457290,299202,376750,372963,239027,787460,55543,829281,118206,40656,1000935,899568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]