SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501407 LIMIT 1 [ RunTime:0.000809s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501407 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128828,580678,818044,765650,550979,743325,76408,1034632,302023,820057,136986,159947,791948,903879,497100,788525,380051,144919,407717,8051,519764,994632,728351,18510,618852,1025421,691705,387565,464832,535337,192125,166388,18260,4172,941959,374251,395453,1007272,779143,623134,177362,487484,129402,153019,848315,814134,441228,251051,594669,834850,567126,968413,895334,747335,97391,180359,327538,643750,847381,128678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003846s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]