SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498514 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498514 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945501,974934,149590,197160,797408,197128,562646,379622,498728,57103,773227,384958,957611,525750,177579,911483,288049,233032,766561,872721,1032554,246820,940636,425344,489070,72526,759230,819637,831769,375730,248360,181579,612364,81577,297158,201874,71635,321374,334302,115056,181641,575517,200855,202377,153335,229655,911771,775661,688620,391442,833606,677775,34325,502048,305135,510614,949388,553587,193142,36257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]