SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427690 LIMIT 1 [ RunTime:0.000552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427690 [ RunTime:0.003208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411549,761434,172421,614903,891708,1022041,108081,377978,604551,626530,1016956,451212,861054,133997,80539,885830,355695,136648,932736,137188,387896,371837,406650,256927,469560,909984,733240,959348,775554,889910,138835,746888,640046,688635,176136,620690,776560,777980,563510,712433,973239,957183,115210,1087,50990,318038,182994,936777,655731,719935,735009,201732,790578,2769,151043,555204,526632,326014,737088,994056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]