SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 122009 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 122009 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204646,11939,1012057,549070,417542,273840,647630,936547,19052,258488,47480,684074,628710,352122,158470,295375,707352,691781,507314,309349,617568,487604,585330,329674,840614,77787,866125,734227,821711,996635,883555,549079,141612,309969,1034104,89159,224323,212116,541693,1039177,944520,44239,615908,115771,449482,911018,361430,535949,944437,162542,901159,364852,245899,168752,270495,302627,624361,957134,1010016,604489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 122009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 122009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]