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` = 504857 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504857 [ RunTime:0.002051s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843609,535437,101732,19032,39580,923203,831705,856554,332183,122427,403793,627028,559176,384997,711165,304687,667366,200295,774318,78038,776110,556781,926851,252654,115094,964518,69295,386513,587845,123052,439940,573988,817086,941947,263309,842495,795317,884756,794159,884330,154907,267867,908987,952679,280402,486825,912649,994382,305899,475608,351607,554351,5630,65847,106705,365933,906787,856460,641194,575115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]