SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470721 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470721 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269936,372712,877676,964081,345828,288049,1026903,752771,441187,776224,649867,475749,528688,629946,442384,765165,268136,49525,89443,538396,338704,1043935,640455,941963,592394,824336,242406,692170,661850,559381,353319,598760,203511,205306,46266,909921,161061,340804,855484,570959,880492,807177,385960,380967,409929,1031072,1037696,562897,1039080,381179,646322,313183,947189,783913,979320,94491,658123,683607,318463,905656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001576s ]