SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 994484 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 994484 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046806,498724,109136,71497,206233,405260,327604,297180,776017,1015438,605093,88029,212046,672696,716218,896890,604222,48265,652325,506331,986899,150755,838939,711901,179266,263706,937336,269729,613189,114890,678499,30142,854139,511000,1036328,103333,353672,729145,522937,323643,45218,821154,36465,558765,819028,873544,237565,513491,145477,670925,162871,567007,387841,164675,237908,208089,336941,830946,109637,101833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 994484 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 994484 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]