SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414399 LIMIT 1 [ RunTime:0.000582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414399 [ RunTime:0.002745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615403,808722,18154,811281,49906,210205,133774,854357,366722,175942,394010,947372,520247,187863,569022,51483,132566,1008389,25860,561516,49566,294392,432046,288693,744325,307257,318174,824049,862778,282597,816659,1017364,331798,332971,726474,1013715,223739,239410,721657,974991,668260,931349,323963,884719,63074,556486,1039969,725539,923006,918116,430268,451504,645666,364961,116177,774587,691954,640734,797650,499280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]