SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543214 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543214 [ RunTime:0.002993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337949,196367,327498,329973,562360,313411,429000,841442,90381,261620,893613,817579,572764,223221,180346,277524,951394,352677,592886,1044279,92206,975762,232748,846388,627151,1045735,350826,140250,196520,313561,777410,454292,531635,161866,579500,440269,796784,207721,112678,670874,75359,300375,574200,749839,731233,723504,765618,850194,667230,873752,157197,89583,729625,923004,176546,890185,225136,861026,436331,785426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001809s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001449s ]