SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346650 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346650 [ RunTime:0.002999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888076,494689,974548,752423,251703,327018,311574,900438,803090,626149,621313,913536,249243,279781,821288,592915,916047,821794,329394,668657,389548,599649,854478,215888,622869,503820,488796,149786,521355,812884,167020,485822,183478,1012825,480134,736055,317298,857786,219879,1030186,690566,991990,74580,88428,323622,827185,250934,493633,754430,1001142,729066,606651,821797,1017318,204074,933813,930897,274930,691512,92770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000382s ]