SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041666 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041666 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411249,37430,983849,522776,203283,738669,419956,489627,546248,673518,329928,172502,1041845,948820,396932,521347,351273,993826,519300,130106,987939,788098,477277,1026295,177738,154520,467298,306686,231002,427029,167421,849898,419473,346871,1045073,332495,627510,926929,418982,715372,464350,260216,611836,886229,130427,366532,581095,325298,872920,335148,655007,300001,49415,1041053,446852,745134,501776,281597,586889,395423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041666 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041666 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]