SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501279 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501279 [ RunTime:0.002264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (632029,225416,598251,297789,669575,398473,490408,474991,638224,307522,446504,431229,1005658,516614,629734,52921,418968,374631,768507,566947,789045,999438,1029407,613557,54276,143937,235365,486706,106465,286950,750427,539636,402150,994386,320184,497179,493722,376387,206852,193437,278037,459043,1028988,624145,921957,185491,29967,672301,105479,19301,475526,440508,109182,577845,946700,360705,53911,806901,110890,17359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501279 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501279 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003931s ]