SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044522 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044522 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214184,438341,227322,652286,990723,1018610,221764,760953,981624,521438,387610,973178,975908,86832,849115,776061,951435,917916,145290,919684,129694,289999,297103,987235,81046,578821,945993,704450,765890,126812,34445,255694,179171,875644,788871,1013727,303083,64660,570079,627462,719550,152123,1010463,859242,658865,409398,764393,576655,849513,972855,636777,116929,680291,334178,594795,704416,866582,81017,758399,327717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]