SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391018 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391018 [ RunTime:0.002992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649926,759793,888716,267588,812087,511179,669027,678702,645369,761535,36351,28701,907239,900569,277810,853592,462408,967519,1041809,994788,1002878,166735,316889,431180,115117,578794,152854,772958,405047,690884,291653,719391,593303,685084,234459,87994,923674,208720,616872,511491,573235,436797,672891,247575,535377,268170,1046740,843920,33146,605580,435913,450566,533144,172616,413917,95889,543499,922492,697579,235583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002459s ]