SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017514 LIMIT 1 [ RunTime:0.001130s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017514 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561944,231823,488714,695350,1032374,195552,381776,213707,901620,413292,214317,1013262,262239,453085,781878,166619,568879,990101,488096,938331,160269,144928,875256,466673,570752,199869,229291,1034160,354334,700789,747168,122363,240028,358927,954082,794731,1026071,420452,211229,490870,387849,156352,538094,688973,531150,526723,619108,411781,165427,1021821,33486,213111,754718,490687,419699,183516,629610,889302,628397,613420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001531s ]