SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405251 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405251 [ RunTime:0.002429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901418,881465,285213,963082,356829,201738,433295,803933,374756,50361,488583,290945,984952,127940,876201,683295,804809,123145,79827,27961,137788,916319,370123,575469,302927,496483,269877,147245,585597,55835,544116,616220,240996,1005222,61250,425184,475396,68733,346326,22405,758561,90795,624489,1025225,914050,322746,721628,484046,53232,486615,117255,719934,968069,366843,326780,843308,407714,275491,177281,34748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]