SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3188 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3188 [ RunTime:0.002667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (898165,126133,180015,328149,10220,567281,444528,459948,108891,317315,636165,912379,141873,387024,748879,320568,231701,678104,439985,372169,412047,496886,318677,320098,105164,159028,56422,22759,95683,795493,558473,520158,820370,178554,15449,223782,879249,863775,506050,240497,283593,971934,90054,508604,694781,860346,721687,331547,160873,656841,238023,449311,218409,163888,337559,246992,799690,352345,386780,10473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]