SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001872s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631009 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631009 [ RunTime:0.002091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543612,499651,602983,689686,779490,993650,978808,533784,655998,272066,10423,790606,873189,28589,337006,840471,467534,173169,43000,243625,683848,409160,320492,955886,1030809,282701,939117,1038200,89738,162842,699463,105935,69196,389498,519928,1034977,75177,597021,404848,343769,966606,674903,912917,686915,33230,39729,759315,644638,363014,508637,411388,754836,293605,805367,328032,472700,684850,755812,207141,886350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]