SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565226 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565226 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214850,374884,263527,955973,114486,748597,177468,81164,449837,517853,110312,1037872,1023118,854350,1004625,855589,626019,141844,97005,879289,699499,745278,548998,623646,466353,85184,967949,327723,806244,349737,936980,565188,208631,135217,523203,542000,483474,849649,660668,325813,365175,292496,82433,784836,806628,558027,38110,476281,626962,241788,271277,807960,374767,307809,473501,841312,1013514,168890,897327,448832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]