SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044582 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044582 [ RunTime:0.007666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360497,659936,374643,461419,245399,302516,952828,831804,294093,130748,166908,504291,435144,1041472,262822,34051,477867,434794,647462,101645,126182,789122,106008,789058,670436,546987,304598,574468,1046789,607155,727369,490106,931393,330085,189587,800069,520547,538551,273594,51296,632896,892109,709151,783742,68372,605298,439426,269661,149199,262585,535481,378340,422343,875085,966561,270305,504464,582823,364461,779201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]