SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 164653 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 164653 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38645,679893,388699,454062,138566,441597,142129,60834,627727,26632,129852,18206,421876,724115,221121,317245,781069,439924,415979,630745,543780,541000,317019,463241,586248,419623,212541,916908,10614,514099,922270,926881,179925,557922,329951,802456,235940,275570,562514,287685,681219,389020,51480,940341,499206,843696,288592,924019,128664,147895,395808,746989,271393,318736,3929,175222,327428,510268,1044702,478746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 164653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 164653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]