SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282500 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282500 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729635,554145,1045460,187670,714,917139,515921,540460,147978,1041516,573693,336803,1008080,131670,132146,917781,221530,349273,417130,449844,792357,427263,189256,880752,806554,829046,747396,345669,253340,780058,872079,1039148,1001704,179857,581037,420676,177119,337600,1039141,495671,296987,911797,418400,265603,800497,497301,645040,1026956,375818,346145,798350,126944,493541,192273,428049,260523,823455,807825,231085,705958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]