SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200027 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200027 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426110,369896,334537,410340,1032306,570874,600770,612803,783312,458321,126114,137099,15447,809718,459161,765291,351067,100873,1025807,81216,10332,232420,878795,837866,309737,476772,968359,731773,770048,316720,597172,464079,704735,127247,150639,453822,64687,119234,108180,709654,4753,218833,976364,686269,739504,738143,160185,583075,1035106,124863,709455,728530,890108,998098,87970,749719,723667,136275,776578,99758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]