SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405425 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405425 [ RunTime:0.002226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041456,485287,875435,936071,861188,548416,603113,911963,449283,249480,613473,350059,710167,1001843,681749,529632,747383,2900,956551,529991,238809,338643,209566,595996,337612,311236,421816,565541,415294,154888,611838,447766,505720,255065,502813,202742,927200,403606,625963,964055,888360,792595,77461,977309,945688,314812,439718,27405,61958,370464,918774,297199,171713,56880,902688,814010,206123,160024,532322,967116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]