SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35482 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35482 [ RunTime:0.003148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436034,37998,845391,714011,493646,641780,472496,277917,40055,224323,1192,390722,618949,900962,696729,742918,972005,767762,729400,994473,37219,521743,493219,391007,53331,372729,967046,1031701,891795,144116,948888,212691,1011485,380960,988214,129518,574743,6013,564554,818536,469367,202579,775689,111671,802694,284805,1035312,469981,105168,24949,603783,323811,782991,306049,763480,765750,500850,122595,831503,543258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]