SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10498 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10498 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392197,491857,576206,17679,363575,374854,405276,261222,23462,583168,597457,685049,387632,36683,257978,94498,404352,72957,617691,910193,986764,402974,517504,233744,677025,31334,248988,28495,685138,514095,341449,424756,321689,649260,765728,469051,613832,265707,1048036,957605,792492,255534,882814,406647,335646,981136,1019474,100593,383077,256831,456971,676539,719296,592763,222218,297706,888244,429444,908571,322828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]