SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 14700 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 14700 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522774,863087,621506,922300,513328,556913,621755,565330,159563,1046230,931053,753045,139975,947973,201998,78402,263015,653492,802062,102964,835100,485412,380180,442879,549404,622495,1046960,276890,986037,20182,265560,316190,1014451,1020487,116779,921870,800930,25486,830272,679921,19766,342876,189080,742021,244885,322175,441341,978845,975260,685764,372785,716371,119521,188500,1031561,462060,702033,819693,850054,987927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 14700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 14700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]