SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539455 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539455 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53385,727759,23333,679744,263097,4009,553271,284607,730524,789517,44656,251030,503086,776743,479662,375670,965063,247096,407909,30402,59902,977728,428758,285467,47679,644094,121174,264615,356159,849943,454285,212815,809957,75750,339707,426932,105656,355566,974143,900168,505653,290986,781259,681562,696652,11869,853859,491192,682559,483063,103827,917,962896,137849,508467,1021140,553233,948825,484593,116409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]