SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001744s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416868 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416868 [ RunTime:0.004433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414030,406203,197538,123448,464401,219457,545513,157904,835497,37247,1043939,161878,1041742,326471,575560,515980,831405,44459,884559,399693,596071,926361,774338,131708,616086,144099,732968,699193,899886,141206,635414,635014,464648,212264,512898,370555,133282,945933,965711,155247,571411,657971,980385,557381,860664,1009055,369653,777062,137789,979539,728760,665576,300284,531831,28964,161177,748442,782008,292815,426761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416868 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416868 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]