SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313140 LIMIT 1 [ RunTime:0.002597s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313140 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827973,208143,253004,928031,927340,146535,293516,579095,820944,949781,136852,558435,133535,952711,894160,568196,229442,912926,296697,467877,481568,800117,356393,578756,2559,693622,277068,1029779,194449,277045,1016182,353027,43473,836663,559854,468847,162788,68794,676275,381397,446843,354387,985732,193544,402335,467252,915505,881682,109332,1027734,68270,816241,721845,314847,58092,509320,892231,146047,664281,619441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]