SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398682 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398682 [ RunTime:0.002177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44464,464219,626009,931858,29672,769411,510036,540864,428010,960070,229983,866650,683306,569791,407108,591162,1017873,696664,340424,577548,558926,880668,11043,224087,364732,1032297,583265,564280,786356,592039,742940,875882,727290,415476,303465,892402,540527,513577,253748,424959,609012,835843,302765,1005684,883838,700928,997305,870506,710611,1007360,229297,569459,161673,233441,929411,1023892,810291,142254,46597,479869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]