SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445445 LIMIT 1 [ RunTime:0.000624s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445445 [ RunTime:0.003751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620654,348671,804179,981088,817718,500021,193375,77246,410131,944504,354070,812819,41006,89160,218864,179275,884194,325803,816344,67953,443412,770289,999541,247510,576592,773752,906738,608189,663510,588118,471671,750808,394937,819919,559244,842386,162854,453115,237706,988896,90774,560285,470578,984098,444705,442652,678668,619869,582416,903884,102021,896651,242903,945376,1001968,834083,692409,981024,773785,781714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001770s ]