SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 761400 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 761400 [ RunTime:0.002758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917672,869652,686170,673393,432979,615686,941280,24130,162281,764450,280164,968699,1017590,544065,128841,736965,572938,850628,1046389,1032527,949644,756396,685649,753023,793940,1027233,762091,576826,728382,635057,855505,153002,333729,571683,380017,918293,380629,440617,130622,756717,1014287,930359,574715,13691,623058,455228,635383,113198,185744,361324,367006,65011,532543,589901,903318,110867,529249,971501,319038,547805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 761400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 761400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]