SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 235218 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 235218 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368495,983807,645606,252383,451391,623972,175086,670034,488316,217111,108264,773496,15062,46297,352218,479090,1005163,94609,505007,378031,789530,410161,706693,684465,999965,165285,775863,890496,441961,183217,191297,942833,792293,602813,236136,1020323,776346,823343,885075,62360,959254,116607,576312,972791,157652,790000,61562,882840,64112,419074,342924,151417,462087,474219,10316,905845,247673,44839,609712,791009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 235218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 235218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]