SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539914 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539914 [ RunTime:0.004004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169743,359789,951592,520358,232280,278617,837308,487183,573013,368327,720798,757193,105399,201479,935940,222308,1292,115835,713143,906692,577625,681001,102345,988058,396205,608481,605572,164715,354270,70682,413540,39318,24378,1310,139689,43452,758235,99084,498758,173298,298013,1020493,384072,506916,788480,171217,212882,25093,161656,800236,1024619,67337,488517,430012,739398,701729,660911,402799,396379,864158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000875s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]