SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50401 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50401 [ RunTime:0.002039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677917,96512,794873,532451,128988,856802,284014,133897,524376,363331,342688,547429,793532,314820,819642,481629,274559,1011633,901224,313702,302646,690801,88801,549039,745048,892920,236551,873014,851369,726677,737182,532724,908468,22059,1012742,325365,940774,911681,475520,629701,224671,136926,388647,444627,694708,138824,646832,412656,680331,814869,849867,360937,737839,688430,275988,186512,142688,861402,209522,1011087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000725s ]