SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41192 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41192 [ RunTime:0.002958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012300,629386,923686,738972,449823,252930,875765,185101,433895,289896,707442,47269,229063,153341,824620,208035,246109,362086,88591,401444,553393,211501,594,170327,500208,688033,216428,38388,876490,150650,372410,824455,145229,754519,691762,229490,866888,869550,65187,312142,380484,26083,818280,276991,349359,461234,413006,118146,578007,195166,343077,848229,364041,420377,475436,573874,226225,573713,787181,275649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]