SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506761 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506761 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005183,291817,953112,346092,630561,694380,618727,961493,422385,619112,901211,338342,839303,671186,789054,978837,51041,978425,278101,779178,426680,518440,138247,163090,901366,428943,84238,189220,968185,762466,415029,920838,163135,7281,1027775,515627,588529,289752,330570,567985,527226,394359,484259,628615,115351,844764,541700,217099,813891,641416,163984,85004,231969,877298,854241,204377,524302,823759,330643,709010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506761 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506761 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]