SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506375 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506375 [ RunTime:0.002550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661035,78116,84413,489370,153834,418980,684804,843585,587751,272013,937474,874983,206230,687000,467051,1001284,924549,585800,395093,759681,503462,783233,931894,786682,770291,990516,384661,78346,854504,852411,169226,10924,9543,779609,44777,762500,141863,14525,654549,771769,1038464,640864,583031,227905,296286,654770,103034,707029,43051,405744,930576,244653,253852,81293,823717,370460,389178,475897,435081,283187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011711s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506375 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506375 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001809s ]